class CreateCouncillors < ActiveRecord::Migration
  def self.up
    create_table :councillors do |t|
      t.column :first_name, :string
      t.column :last_name, :string
      t.column :common_abbreviation, :string
      t.column :email_address, :string
      t.column :address, :text
      t.column :home_telephone, :string
      t.column :home_mobile, :string
      t.column :town_hall_telephone, :string
      t.column :fax, :string
      t.column :end_of_term, :string
      t.column :further_information, :text
      t.column :ward_id, :integer
      t.column :party_id, :integer
      t.column :official_council_webpage_listing, :string
      t.timestamps
    end
  end

  def self.down
    drop_table :councillors
  end
end
